package com.ews.dialect;

import java.sql.Types;

import org.hibernate.dialect.Oracle10gDialect;
import org.hibernate.dialect.function.SQLFunctionTemplate;
import org.hibernate.type.StringType;

public class OracleDialect extends Oracle10gDialect {

	public OracleDialect() {
		super();		
		registerColumnType(Types.VARCHAR, "varchar2($l char)");
		registerKeyword("within");
		registerKeyword( "listagg" );
		registerFunction("gbk_order", new SQLFunctionTemplate(StringType.INSTANCE, "nlssort(?1,'NLS_SORT=SCHINESE_PINYIN_M')"));
	}

}
